﻿CREATE TABLE [enq].[Trade]
(
	[Id] INT NOT NULL,

	[AccountId]		INT NULL,	
    [InstrumentId]	INT NULL,

	[TradeDt]		DATE NULL,
	[ValueDt]		DATE NULL,
	[Activity]		INT NULL,
	[Qty]			MONEY NULL,
	[Price]			MONEY NULL,
    [TradeCcy]		CHAR (3) NULL,
    [Commission]    MONEY NULL,
	
	[Memo]          VARCHAR(255) NULL,

	CONSTRAINT [PK_Trade] PRIMARY KEY CLUSTERED ([Id] ASC)
)
